Replenishment Parameter Maintenance
The Replenishment Parameter Maintenance program allows the buyer to configure the procurement calculations. Based on the selections, the scope of the setting will be indicated in the Scope Listing. For example, a Purchase Line is for a range of items from a particular vendor and its parameters can be defined either at the Purchase Line or Warehouse / PLine level. The desired replenishment scope is selected by entering Warehouse, Vendor, Purchase Line or Item.
An item’s parameters can be entered and the appropriate scope level is chosen during entry. Depending on the scope selected, a set of parameters can apply to a range of items. For example, an item can be selected by entering its part number, and then the scope can be set to the Purchase Line for the item. All items that are members of the Purchasing Line would then have the settings applied according to the hierarchy. The settings for an item, or other scope level, and their inherited settings can be viewed by scrolling through the parameter options line view. This view displays the category, title, current applied source and the expiration date and memo. The view supplies a quick reference allowing a buyer to update parameter settings and apply a new scope as needed. If the scope is no longer needed and is deleted, or has expired, the next scope level settings will be viewed in the line view.
Purchase Line Entry (ICE920)
Use the new Purchase Line Entry (ICE920) program to group together items you usually buy together. The path to the program is Inventory Control>File Maintenances>Purchase Line Entry (ICE920). A Purchase Line is for a range of items from a particular vendor and its parameters can be defined either at the Purchase Line or Warehouse / PLine level. In Replenishment Parameter Maintenance, an item’s parameters can be entered and the appropriate scope level is chosen during entry. Depending on the scope selected, a set of parameters can apply to a range of items. For example, an item can be selected by entering its part number, and then the scope can be set to the Purchase Line for the item. All items that are members of the Purchasing Line would then have the settings applied according to the hierarchy. You can edit existing purchase line, add purchase lines, and change the primary vendor for an item that may exist on another purchase line. Purchase Line Entry ties into fields in Item F/M (ICF910). Purchase Line Entry sets purchase line information for an item for a vendor. This information overrides the vendor defined in Item F/M & over writes it in the Item file. If you modify the primary vendor on a purchase line, the vendor is updated for all of the items on that purchasing line.
Lead Time Review
The Lead Time Review program is used to modify to Lead Time for a receipt. In the upper portion of the screen, you can specify the warehouse, item and indicate the type of documents you want to view—transfers, purchase orders or both. You can also specify the PO number and receipt or Transfer number and shipment line. The transfers shipment lines and purchase order receipt lines are displayed in the browser so you can modify the lead time information as needed.
This modified lead time called “Qualified Lead Time” is used in calculations concerning lead time. Any changes to the Lead Times will be reflected by recalculating the replenishment Order Point and Line Point for the item. If there is no qualified lead time then the actual lead time is what is used in calculations.
The program lists abnormal, ignored or all Lead Times for items and allows for Lead Time correction.
For Example: Since actual lead time is the difference between the order date and the receive date. A line in Lead Time Review might show an actual lead time of 7 days. In some cases you may need to “qualify” that lead time, because something caused that line arrive later or sooner than indicated. In such a case actual lead time would stay 7 but you would enter the qualified lead time that represents the correct lead time value that is to be used in calculations in the system. You can select the Abnormal checkbox to flag a Lead Time as abnormal if it is more than 50% different from the average or if the ARP Lead Time minimum or maximum threshold has been reached. The ARP minimum and maximum thresholds are established in the Inventory Control Replenishment Parameters and can be in effect for various product scopes.
There are times when lead time on a particular receipt should be ignored and not factored into the average lead time. Generally, this occurs when a product’s lead time varies significantly from the average, and, if factored into the average, could result in an order point that is too high or too low. You can select the Ignore checkbox to prevent this lead time from be included in average lead time calculations.
Usage Review
With Usage Review (ICE555) you can view qualified usage for any document that has recorded usage for the selected warehouse and item combination you specify. All usage on this screen is sum of usage for the specified warehouse and all warehouses the specified warehouse replenishes. You can apply a set of filters to define the usage lines displayed in the browser (which are displayed in descending date order). You can filter for the beginning date for the display, and the number of days (30, 60, 90, or 120) from that date to display. You can also check the Abnormal check box to only display those dates already listed in the browser that have Abnormal (both High and Low) indicated usage. When making any changes to the date or number of days you must select the Apply Filters button to enact those changes so that the browser will redisplay with appropriate lines. You can double click a line to access the Usage Review Detail (ICE556) program to modify qualified usage values/dates. Only lines having usage will be able to access the Usage Review Detail program. Once you have modified the qualified usage for a document you can return to Usage Review and select the Recalculate Usage button to recalculate qualified usage for specified warehouse/item. This modified usage, called qualified usage, is used in usage calculations performed by the Daily Sales Register.
Cost Discrepancy Entry
Use Cost Discrepancy Entry (ICE610) to identify and correct documents that have been updated with the wrong cost. The receipt record (ICRCPT) will be updated immediately so that any further disbursements of that receipt will be at the correct cost. The General Ledger is updated when the Cost Discrepancy Register is run.
A cost discrepancy will not update any ICWHSE cost fields – i.e. the last, average or manual costs at the time of the receipt or disbursement cannot be modified.
If the costing method is anything other than LIFO or FIFO, no cost changes will be made to the past documents that make up the disbursements.
The cost of inventory going into the Inventory GL account (based on receipt cost) is updated regardless of costing method. Inventory receipts in the ICRCPT table, the source documents and the GL impact are updated for cost discrepancies. For Disbursements that are incomplete in the ICRDST table (with a costing method of F/O for the source document) the cost on the source document line is updated. If the disbursement is complete in ICRDST the cost in ICRDST and the GL impact are updated, and the cost on the source document line is also updated, for source documents that are still available. Disbursements are updated on a LIFO/FIFO basis even if costing method is something other than LIFO/FIFO.
Process Warehouse/Item Records (ICU960)
Use this program to process warehouse/item records automatically for a range of items in the item file. You can import and export of data to Excel for review and updates. This can replace utilization of existing warehouse item records for an alternate warehouse to serve as the basis and allow initial replenishment parameter settings and expiration dates in an offline mode.
Warehouse/item records can be imported, exported or pending records removed for one warehouse each time the program is run. This program may save you time during initial inventory setup or in the event that you are opening a new warehouse.
Cost Discrepancy Register (ICR610)
Use this program to print a register of cost discrepancies entered in the Cost Discrepancy Entry (ICE610) program. If any cost discrepancies have been entered, but not posted, you must run the Cost Discrepancy Register before you can close the GL or IC period. All records will post to the current GL period. The GL account numbers will come from the receipt record (ICRCPT) so they will post to the same accounts as the original receipt. The GL Update writes journal entries for the cost discrepancy from the receipt as well as any disbursements from that receipt.